PlReasonQuestion 
Logical Entity Name  PlReasonQuestion 
Default Table Name  PlReasonQuestion 
Physical Only  NO 
Definition 
 
Note 
 

PlReasonQuestion Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PlReasonQuestionID(PK)    int  NO 
 
Code    nchar(8)  NO 
 
Descrip    nvarchar(500)  NO 
 
Active    bit  NO 
 
PlReasonID(FK)    int  NO 
 
QuestionType    char(1)  NO 
 
QuestionNumber    int  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
Ts    timestamp  NO 
 

PlReasonQuestion Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_PlReasonQuestion_PlReasonQuestionID  PrimaryKey  PlReasonQuestionID 

PlReasonQuestion Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
PlReason  Non-Identifying  One To Zero or More  FK_PlReasonQuestion_PlReasonID_PlReason_PlReasonID      PlReasonID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_PlReasonQuestion_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
PlReasonQuestionAnswer  Non-Identifying  One To Zero or More  FK_PlReasonQuestionAnswer_PlReasonQuestionAnswerID_PlReasonQuestion_PlReasonQuestionID        NO  YES 
PlReasonQuestionResponse  Non-Identifying  One To Zero or More  FK_PlReasonQuestionResponse_PlReasonQuestionID_PlReasonQuestion_PlReasonQuestionID        NO  YES 

PlReasonQuestion Check Constraints 
Check Constraint Name  CheckConstraint